TrustRadius Insights
Aginity has proven to be an invaluable tool for organizations looking to improve their work efficiency and productivity. Users have found …
Overview
What is Coginiti?
Coginiti (formerly Aginity), the collaborative intelligence company, empowers users to get consistent answers to any business question. The Collaborative Intelligence platform provides a unique workspace that empowers the entire organization to build, share and reuse analytics. By making quality…
Recent Reviews
Pricing
N/A
Unavailable
What is Coginiti?
Coginiti (formerly Aginity), the collaborative intelligence company, empowers users to get consistent answers to any business question. The Collaborative Intelligence platform provides a unique workspace that empowers the entire organization to build, share and reuse analytics. By making quality…
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Would you like us to let the vendor know that you want pricing?
2 people also want pricing
Alternatives Pricing
What is Klipfolio?
Klipfolio PowerMetrics is a metric-centric business intelligence platform. Data teams are able to bring all of their data together and create a catalog of verified metrics that end users are able to explore and visualize using self-serve dashboards and reports.
What is Active Query Builder?
Active Query Builder is a component for business applications which helps users without any SQL experience to work with SQL queries and get data fast. Users can get a clear view of database schema and design SQL queries with natural point-and-click actions rather than tedious typing. Active Query…
Product Details
- About
- Tech Details
What is Coginiti?
Coginiti Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
Comparisons
Compare with
Reviews and Ratings
(13)
Community Insights
TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!
- Business Problems Solved
- Pros
- Cons
- Recommendations
Aginity has proven to be an invaluable tool for organizations looking to improve their work efficiency and productivity. Users have found that the ability to access databases and external files for integration has greatly enhanced their data analysis capabilities. The system's excellent data synchronization ensures consistency, which is vital for accurate decision-making. Multiple departments within organizations, including business intelligence and analytics teams, have benefited from Aginity's direct interface to databases like Netezza and RedShift, allowing them to design, create, and execute SQL queries seamlessly. For users dealing with RedShift instances, Aginity has been particularly helpful in performing queries and conducting maintenance tasks. Prior to using Aginity, users encountered performance and productivity issues when running queries in RedShift's editor. Overall, Aginity serves as a central hub for database management, analytics tools, and SQL code reusability, empowering users to drive innovation by sharing their SQL skills.
Intuitive User Interface: Many users have found the user interface of the big data analytic software to be intuitive and easy to use, especially when connecting to various databases. They appreciate how it simplifies their workflow and makes it easier to navigate through different features.
Transparency of Database: Reviewers have appreciated the transparency provided by the software's database, which includes detailed table information such as columns, data types, data length, and space usage. This feature has been particularly helpful in understanding and analyzing the structure of the database.
Collapsible Object Browser: The object browser in the software is highly praised by users for its ease of navigation. It allows them to have a clear picture of tables and views, along with their composition. Users prefer its collapsible format organized by schema names, table/view names, and specific columns over other similar software options.
Cons:
Tedious Navigation: Some users have found the navigation in Aginity to be tedious, causing frustration and slowing down their workflow. They mention difficulties in finding specific features and navigating between different sections of the software. Automatic Character Creation: Several reviewers have expressed dislike for the automatic creation of parentheses and other characters in Aginity. This feature often leads to deleting unnecessary parts, resulting in wasted time. Users suggest that having more control over this auto-creation process would improve their overall experience. Lack of Log Feature: Users have mentioned that Aginity lacks a log feature for running codes and troubleshooting. This omission makes it difficult for them to track errors or identify issues with their code execution. They feel that having a log would greatly enhance their ability to debug and optimize their queries.
Users commonly recommend the following when it comes to using this software:
-
Prioritize SQL proficiency: It is important to be well versed in SQL before using this software. This will allow for better utilization of its capabilities.
-
Minimize simultaneous queries: To avoid freezing and optimize performance, it is recommended to minimize the number of queries running simultaneously.
-
Give it a try: Trying out the software is suggested to see if it meets one's expectations. This will help determine if it aligns with specific needs and requirements.
Users find this software worth using for data analysis and analytics on large data warehouses and big data. It has been compared to MySQL Workbench and praised as a great tool for working with Amazon databases, particularly RedShift. The simplicity and usefulness of the SQL command area and the ability to view data simultaneously are appreciated. The learning curve for this software is reported as manageable, making hiring a consultant unnecessary.
Reviews
(1-3 of 3)Companies can't remove reviews or game the system. Here's why
December 10, 2021
Easy to navigate,Clean and Attractive GUI, Aginity reduce business continuity risks.
My experience overall with Aginity has been very satisfying, this is because it offers Full-featured just at our disposal. It is easy to use, the setup process is not complicated. It offers a quality analytics tool [that] empowers our business to complete successfully on this aspect. The company expert team includes business technologies, innovators, and entrepreneurs who work collaboratively to produce high-quality services.
- Aginitu Amp gives both data scientists and business users the capabilities to build, reuse and share advanced analytics easily.
- The Intuitive user interface allows data scientists and business analysts to build, reuse, and share analytics without SQL or coding.
- Error message windows and closes before the user can read them, hence leaving the user in suspension mood, and hovering my finger over the print screen capturing them.
- Navigation sometimes its a little bit buggy.
- Atomic analytics.
- Any data source.
- Any user from clicker to coder.
- Modern governance model.
- We are able to create analytics without needing programming skills.
- Query auto-completion.
- Database exploration includes schemas, tables, columns, distribution keys, sort keys, and so forth.
- Attractive GUI and easy to navigate for easy data reporting.
Aginity products make every line of code searchable, reusable, and easy to understand for individuals, teams, and enterprises. The User dramatically accelerates the production and operationalization of analytics by reusing them rather than recording them, hence allowing them to work more efficiently and provide consistent actionable results for Business growth.
April 26, 2017
Analytic Agility with Aginity
Our business intelligence department all use Aginity to access our RedShift data. Our analyst team uses the tool to generate reports and run analysis on our data warehouse which lives in Amazon RedShift. Our business intelligence engineering team uses Aginity to perform some of the RedShift operational tasks and to validate data within the data warehouse.
- Query auto-completion
- Database exploration including schemas, tables, columns, distribution keys, sort keys, etc.
- Common scenario query samples, and easy access to table DDL
- Table size operational report
- Free community edition
- It would be helpful if the table size report could make it more obvious which tables need to be vacuumed. You can figure it out with the report, but can't just glance down a list.
- Error message windows often auto close before you can read them leaving me hovering my finger over the print screen trying to capture them.
- The auto-complete feature is a bit finicky. Many common scenarios which happen while writing a query by hand such as an unclosed parenthesis can cause the auto-complete not to trigger.
- Since the tool is free it doesn't take much to get a positive ROI.
- Since RedShift is a PostgreSQL derivative, tools designed for that DB can be used to access RedShift. However, it is much nicer to have a tool that is RedShift aware and understands the slight differences.
- Query auto-completion makes writing queries much quicker and less error prone.
- The database management features are a nice plus that many comparable tools for RedShift and other databases don't provide.
Like all of the other various SQL querying tools that I have used, the Aginity Workbench for RedShift has a free community version. Although unlike many of the other tools that I have used, Aginity feels like a tool that I would be willing to pay for. It is feature rich and stable.
April 20, 2016
Aginity Workbench, a Data Warehouse Application That Will Help You Bench Your Work to the Max
It is being used by my department, and possibly some other departments, but not across the entire organization. I know Toad is also a popular tool, since Aginity is specific to Netezza, and Netezza is going to be retired in the near future for my department. It addresses the business need for data analysis, by providing a direct interface to our Netezza database, for designing, creating, and executing SQL queries. It allows transparent data viewing and data research.
- Transparent database -> table information. The columns for a specific table/view is listed out within the object browser, and the object browser is easy to navigate, for providing a clear picture of the tables/views, and what it's made up of. Including column data types, data length, and space usage. The object browser follows a collapsible format, breaking down databases by schema names, following with the table/view names, and then the columns specific to that table/view. This in my opinion, is easier than the object browser that Toad provides, where you have to select into a specific table in order to see it's contents and details, rather than being able to compare and have everything on one page.
- The output window is easy for further data extraction, one can simply copy the data out onto an email, into an excel spreadsheet, or other places as necessary. Data could also be exported from the output window, into either excel spreadsheets, or CSV format files, without the need to convert between one or the other. A special area is reserved for dragging column headers into, and what it does is it groups information by that column. This allows flexible user grouping, without the need of writing SQL queries to group on columns. Often times, in my experience, I find the need to group columns on a to-go basis, where I review the data output, and find the need to group on certain columns for further research and analysis, this option allow me to manipulate the result I currently have, without the need to rerun a query for grouping inclusions.
- Able to cascade query windows between different environments. I often need to cascade query windows between an UAT environment, a RESEARCH environment, and a PRODUCTION environment. To be able to cascade between them, and to reference queries and its results, is a huge plus, that I didn't find in some of the other products I've used. This allow me to reference information in between different environments, without the need to connect back and forth.
- For one, I don't like how the parenthesis are automatically created as a set. Often times I only need to type one part of the parenthesis, but it creates a set of ( and ), forcing me to delete them because I didn't need the other half at where my cursor was. Same goes with any other sort of characters, such as ' '. I understand that it's suppose to be smart, but more often than not, it's causing more inconvenience and wasting more time, than actually saving time simply because it types an extra ) or ' for me.
- The error message and the log. I would think there probably is a log somewhere, but the fact that I've been using Aginity for close to a year now, and I still haven't found something similar to a log, is saying something about this feature. A log is like a standard thing nowadays, for running codes, to check against what has happened with the code, and for debugging what you have done wrong within the code. It also contains error messages, and help you troubleshoot with a clearer picture. The error message display current is very small and hard to read, sometimes the error message itself is not as easy to understand either. I use SAS on a daily basis as well, I feel like SAS has done a way better job on this issue, than Aginity.
- I think Aginity really allows us to quickly dive into the data, by providing easy and quick access to our database. This allowed us to solve our business problems on an efficient and timely manner. But since it is not a critical component of our department, (a lot of people also use Toad for the same thing, since Netezza is retiring soon, and Aginity, which belongs to IBM, has had legal issues, and is no longer available to new hires of our department. It is sort of our legacy software.)
- SAS and Toad Data Point
I use Aginity extensively for quick data research. Examples include figuring out what the table structure look like, how the data looks like, quick 100 record sample selection, creating a DDL with a list of the column names for further manipulation and analysis. However, for more complicated analysis, or processes that involve multiple steps, including the creation of temporary or permanent tables, I refer to SAS. Especially since SAS allows me to implement macro variables and programs, to automate and optimize repeatable processes.